{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["PR","PR DISTINGIT ","ValLAB","ValLAB_antiga","ValLAB DISTINGIT","ValLAB DISTINGIT_antiga","calcul dies"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":28,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PR","index":0,"n_rows":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,1,0,5],[61,0,61,1],[26,0,26,4],[26,6,26,7],[45,0,45,4],[45,6,45,7],[52,0,52,4],[52,6,52,7],[53,3,54,4],[4,4,4,6],[5,4,5,6],[27,6,27,7],[27,0,27,4],[7,0,7,4],[7,6,7,7]]}
["NOM"]
["TIPUS CONTRACTE",null,null,null,null,null,null,null,null,"(*) Retribucions 2023 actualitzades amb l'increment del 0,5% (nov23 retroactiu gener 23)"]
["DEDICACIÓ",37.5,{"$f":"IF(ValLAB!J20=2,\"Posar dedicació 37,5 hores\",IF(ValLAB!J20=3,\"Posar dedicació a temps parcial\",\"TP: posar les hores setmanals de dedicació / TC: posar 37,5 hores\"))","v":"TP: posar les hores setmanals de dedicació / TC: posar 37,5 hores"},null,null,null,"mesos","dies",null,"(*) Actualització Base Màx. Mín. I MEI amb vigència 1 de gener del 2024"]
["INICI VINCULACIÓ","2025-01-01",null,null,null,null,{"$f":"IF(B5=0,0,SUM(D65))","v":12},{"$f":"IF(B5=0,0,SUM(E65))","v":0},null,"(*) Actualització Increment retributiu 0,5% març 2024 (efectes retroactius 01 gener 2023)"]
["INICI CONTRACTE/PRORROGA","2025-01-01",null,null,"FI CONTRACTE/PRORROGA ",null,null,"2025-12-31",null,"(*) Actualització Increment retributiu 2% juliol 2024 (efectes retroactius 01 gener 2024)"]
["CATEGORIA",null,null,null,"Nº TRIENNIS "]
["Nº Dies Indemnització",20,null,null,null,null,"IMPORT TRIENNIS",{"$f":"(H6*ValLAB!B8)*(B3/37.5)","v":0}]
["COST MENSUAL",null,null,null,null,null,"COST ANUAL"]
["Retribucions:      ",{"$f":"SUM(B10:B13)","v":1703.29},null,null,null,null,"Retribucions:      ",{"$f":"B9*12","v":20439.48}]
["Sou",{"$f":"(ValLAB!K16)*B3/37.5","v":1410.06},null,null,null,null,"Sou",{"$f":"B10*12","v":16920.72}]
["Comp.Lloc de treball",{"$f":"(ValLAB!L16)*B3/37.5","v":188.41},null,null,null,null,"Comp.Lloc de treball",{"$f":"B11*12","v":2260.92}]
["Complement categoria",{"$f":"(ValLAB!M16)*B3/37.5","v":96.63},null,null,null,null,"Complement categoria",{"$f":"B12*12","v":1159.56}]
["Acord mesa universitària",{"$f":"(ValLAB!N16)*B3/37.5","v":8.19},null,null,null,null,"Acord mesa universitària",{"$f":"B13*12","v":98.28}]
[]
["Prorrata mensual extres",{"$f":"ValLAB!O16*2/12*B3/37.5","v":282.51666666666665},null,null,null,null,"Prorrata  extres",{"$f":"SUM(B15*12)","v":3390.2}]
["Prorrata mensual triennis extres",{"$f":"H7*2/12","v":0},null,null,null,null,"Prorrata triennis extres",{"$f":"SUM(B16*12)","v":0}]
["TOTAL PRORRATA ",{"$f":"SUM(B15:B16)","v":282.51666666666665},null,null,null,null,"TOTAL PRORRATA",{"$f":"SUM(B17*12)","v":3390.2}]
[]
["Triennis: ",{"$f":"SUM(H7)","v":0},null,null,null,null,"Triennis: ",{"$f":"B19*12","v":0}]
[]
["TOTAL RETRIB.",{"$f":"SUM(B9+B17+B19)","v":1985.8066666666666},null,null,null,null,"TOTAL RETRIB.",{"$f":"SUM(H9+H17+H19)","v":23829.68}]
["Indemnització RD",{"$f":"(B9+B17+B19)*12/365*B7/12","v":108.81132420091323},null,null,null,null,"Indemnització RD",{"$f":"B22*12","v":1305.7358904109587}]
["Quota patronal",{"$f":"IF(B21>ValLAB!H15,ValLAB!L20*ValLAB!H15,B21*ValLAB!L20)","v":636.84819799999991},null,null,null,null,"Quota patronal",{"$f":"B23*12","v":7642.1783759999989}]
["TOTAL COST",{"$f":"SUM(B21,B23)","v":2622.6548646666665},null,null,null,null,"TOTAL COST",{"$f":"SUM(B24*12)","v":31471.858375999996}]
[null,null,null,null,null,null,"FONS CONTINGÈNCIA 2 %",{"$f":"SUM(H24*2%)","v":629.43716751999989}]
[null,null,null,null,null,null,"Cost amb marge",{"$f":"SUM(H24*B47)+H24","v":32101.295543519995}]
["COST PERIODE ACTUAL (PRORROGA)"]
[{"$f":"CONCATENATE(B1,\" (\",DAY(B5),\"/\",MONTH(B5),\"/\",YEAR(B5),\"-\",DAY(H5),\"/\",MONTH(H5),\"/\",YEAR(H5),\")\")","v":" (1/1/2025-31/12/2025)"}]
[null,"ACTUAL",null,"AMB ARROSEGAMENT"]
["Retribucions:",{"$f":"IF(B9=0,0,B9*(D65+(E65/30)))","v":20439.48},null,{"$f":"IF( (D67+E67+D68+E68)=0,0,B30)","v":0}]
[]
["TOTAL EXTRES:",{"$f":"SUM(B33:B34)","v":3390.2},null,{"$f":"SUM(D33:D34)","v":0}]
["Extra  juny",{"$f":"IF(B17=0,\" \",B17/2*(D65+(E65/30)))","v":1695.1},null,{"$f":"IF((D67+E67+D68+E68)=0,0,B17/2*(D67+E67/30)+B33)","v":0}]
["Extra desembre",{"$f":"IF(B17=0,\" \",(B17/2)*(D65+E65/30))","v":1695.1},null,{"$f":"IF((D67+E67+D68+E68)=0,0,B17/2*(D68+E68/30)+B34)","v":0}]
[]
["Triennis: ",{"$f":"IF(B19=0,0,B19*(D65+E65/30))","v":0},null,{"$f":"IF((D67+E67+D68+E68)=0,0,B36)","v":0}]
[]
["TOTAL RETRIB.",{"$f":"IF(B30=0,0,SUM(B30+B32+B36))","v":23829.68},null,{"$f":"SUM(D30+D32+D36)","v":0}]
["Indemnització RD ",{"$f":"IF(B22=0,0,B22*(D65+E65/30))","v":1305.7358904109587},null,{"$f":"IF((D67+E67+D68+E68)=0,0,B22*(D69+E69/30)+B39)","v":0}]
["Quota patronal",{"$f":"IF(B21>ValLAB!H15,B23*(D65+(E65/30)),B38*ValLAB!L20)","v":7642.1783759999998},null,{"$f":"IF((D67+E67+D68+E68)=0,0,B40)","v":0}]
["TOTAL COST",{"$f":"SUM(B38,B40)","v":31471.858376},null,{"$f":"SUM(D38:D40)","v":0}]
["FONS CONTINGÈNCIA 2 %",{"$f":"B41*0%","v":0}]
["Import L1",{"$f":"B38","v":23829.68},null,{"$f":"SUM(D38+D39)","v":0}]
["Import L2",{"$f":"SUM(B40)","v":7642.1783759999998},null,{"$f":"SUM(D40)","v":0}]
[]
["COST PERIODE ACTUAL  AMB MARGE"]
["Marge",0.02]
[null,null,null,"Amb arrossegament"]
["Import L1",{"$f":"SUM(B43)+(B43*$B$47)","v":24306.2736},"Import L1",{"$f":"SUM(D43)+(D43*$B$47)","v":0}]
["Import L2",{"$f":"SUM(B44+B44*$B$47)","v":7795.0219435199997}]
["                                    TOTAL    ",{"$f":"SUM(B49:B50)","v":32101.295543519998},"Import L2",{"$f":"SUM(D44+D44*$B$47)","v":0}]
[]
["Cost amb marge i retallada  PERIODE ACTUAL"]
[null,"Retribucions","Quota patronal"]
["Import aprox.Retallada 2014",{"$f":"(B17/2)*(D70+E70/30)","v":0},{"$f":"(B55*ValLAB!L20)","v":0}]
[null,"Sense arrossegament",null,"Amb arrossegament"]
["Import L1",{"$f":"SUM(B43-B55)+(B43-B55)*$B$47","v":24306.2736},"Import L1",{"$f":"IF((D67+E67+D68+E68)=0,0,(D43-B55)+(D43-B55)*$B$47)","v":0}]
["Import L2",{"$f":"SUM(B44-C55)+(B44-C55)*$B$47","v":7795.0219435199997},"Import L2",{"$f":"IF((D67+E67+D68+E68)=0,0,(D44-C55)+(D44-C55)*$B$47)","v":0}]
["TOTAL",{"$f":"SUM(B57:C58)","v":32101.295543519998},"TOTAL",{"$f":"SUM(D57:D58)","v":0}]
["FONS CONTINGÈNCIA",{"$f":"SUM((B43-B55)+(B44))*3%","v":944.15575128},"(sense marge)"]
[]
["MERITACIÓ ARROSEGAMENT PAGUES"]
[null,"DATA INICI","DATA FI","Nº MESOS","Nº DIES"]
["TOTAL VINCULACIÓ",{"$f":"IF(B4=0,\" \",B4)","v":"2025-01-01"},{"$f":"IF(H5=0,\" \",H5)","v":"2025-12-31"},{"$f":"IF((C64-B64)>0,'calcul dies'!L5,\"ERROR DATES\")","v":12},{"$f":"IF((C64-B64)>0,'calcul dies'!N5,\" \")","v":0}]
["PRORROGA",{"$f":"IF(B5=0,\" \",B5)","v":"2025-01-01"},{"$f":"IF(H5=0,\" \",H5)","v":"2025-12-31"},{"$f":"IF((C65-B65)>0,'calcul dies'!L10,\"ERROR DATES\")","v":12},{"$f":"IF((C65-B65)>0,'calcul dies'!N10,\" \")","v":0}]
["MERITEN",null,"DATA FI","NºMESOS","Nº DIES"]
["de 01/07 a 30/06",null,{"$f":"IF(H5=0,\" \",(H5)-1)","v":"2025-12-30"},{"$f":"IF(B67=0,0,IF((C67-B67)>366,\"ERROR DATA\",IF((C67-B67)>0,'calcul dies'!L15,\"ERR0R DATA \")))","v":0},{"$f":"IF(B67=0,0,IF((C67-B67)>366,\" \",IF((C67-B67)>0,'calcul dies'!N15,\" \")))","v":0}]
["de 01/01 a 31/12",null,{"$f":"IF(H5=0,\" \",(H5)-1)","v":"2025-12-30"},{"$f":"IF(B68=0,0,IF((C68-B68)>366,\"ERROR DATA\",IF((C68-B68)>0,'calcul dies'!L20,\"ERR0R DATA \")))","v":0},{"$f":"IF(B68=0,0,IF((C68-B68)>366,\" \",IF((C68-B68)>0,'calcul dies'!N20,\" \")))","v":0}]
["Indemnització RD",null,{"$f":"IF(H5=0,\" \",(H5)-1)","v":"2025-12-30"},{"$f":"IF(B69=0,0,IF((C69-B69)>366,\"ERROR DATA\",IF((C69-B69)>0,'calcul dies'!#REF!,\"ERR0R DATA \")))","v":0},{"$f":"IF(B69=0,0,IF((C69-B69)>366,\"ERROR DATA\",IF((C69-B69)>0,'calcul dies'!#REF!,\" \")))","v":0}]
["Període treballat al 2014",null,{"$f":"IF(YEAR(H5)>2014,DATE(2014,12,31),IF(H5<>0,H5,\" \"))","v":"2014-12-31"},{"$f":"IF(B70=0,0,IF((C70-B70)>366,\"ERROR DATA\",IF((C70-B70)>0,'calcul dies'!#REF!,\"ERR0R DATA \")))","v":0},{"$f":"IF(B70=0,0,IF((C70-B70)>366,\"ERROR DATA\",IF((C70-B70)>0,'calcul dies'!#REF!,\" \")))","v":0}]

{"sheet":"PR DISTINGIT ","index":1,"n_rows":63,"n_cols":11,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,1,0,6],[4,6,4,7],[2,2,2,6],[54,0,54,1],[28,0,28,4],[28,7,28,8],[29,0,29,4],[29,7,29,8],[47,0,47,4],[47,7,47,8],[6,4,6,7],[8,0,8,4]]}
["NOM"]
["TIPUS CONTRACTE",null,null,null,null,null,null,null,null,null,"(*) Retribucions 2023 actualitzades amb l'increment del 2,5%"]
["DEDICACIÓ",37.5,{"$f":"IF('ValLAB DISTINGIT'!J20=1,\"Posar dedicació 37,5 hores\",\"TP: posar les hores setmanals de dedicació \")","v":"Posar dedicació 37,5 hores"},null,null,null,null,"mesos","dies",null,"(*) Actualització Base Màx. Mín. I MEI amb vigència 1 de gener del 2024"]
["INICI VINCULACIÓ","2024-10-01",null,null," Periode",null,null,{"$f":"IF(B5=0,0,SUM(D58))","v":3},{"$f":"IF(B5=0,0,SUM(E58))","v":0},null,"(*) Actualització Increment retributiu 0,5% març 2024 (efectes retroactius 01 gener 2023)"]
["INICI CONTRACTE/PRORROGA","2024-10-01",null,null,null,null,"FI CONTRACTE/PRORROGA ",null,"2024-12-31",null,"(*) Actualització Increment retributiu 2% juliol 2024 (efectes retroactius 01 gener 2024)"]
["CATEGORIA","Director",null,null,null,null,null,"Nº TRIENNIS "]
[]
["Nº Dies RD",{"$f":"IF(ISNUMBER('ValLAB DISTINGIT'!J20),IF('ValLAB DISTINGIT'!J20<3,12,\"\"),\"\")","v":12},null,null,null,null,null,"IMPORT TRIENNIS ",{"$f":"(I6*ValLAB!B8)*(B3/37.5)","v":0}]
["COST MENSUAL",null,null,null,null,null,null,"COST ANUAL"]
["Retribucions:      ",{"$f":"SUM(B11:B15)","v":3021.4900000000002},null,null,null,null,null,"Retribucions:      ",{"$f":"B10*12","v":36257.880000000005}]
["Sou",{"$f":"'ValLAB DISTINGIT'!B5*B3/37.5","v":1410.06},null,null,null,null,null,"Sou",16920.72]
["Comp.Lloc de treball",{"$f":"'ValLAB DISTINGIT'!C5*B3/37.5","v":188.41},null,null,null,null,null,"Comp.Lloc de treball",2260.92]
["Complement categoria",{"$f":"'ValLAB DISTINGIT'!D5*B3/37.5","v":1414.83},null,null,null,null,null,"Complement categoria",16977.96]
["Complement de distinció",null,null,null,null,null,null,"Complement categoria",0]
["Acord mesa universitària",{"$f":"'ValLAB DISTINGIT'!E5*B3/37.5","v":8.19},null,null,null,null,null,"Acord mesa universitària",98.28]
[]
["Prorrata mensual extres",{"$f":"(B10-B15)*2/12","v":502.2166666666667},null,null,null,null,null,"Prorrata  extres",{"$f":"SUM(B17*12)","v":6026.6}]
["Prorrata mensual triennis extres",{"$f":"I8*2/12","v":0},null,null,null,null,null,"Prorrata triennis extres",{"$f":"SUM(B18*12)","v":0}]
["TOTAL PRORRATA ",{"$f":"SUM(B17:B18)","v":502.2166666666667},null,null,null,null,null,"TOTAL PRORRATA",{"$f":"SUM(B19*12)","v":6026.6}]
[]
["Triennis: ",{"$f":"SUM(I8)","v":0},null,null,null,null,null,"Triennis: ",{"$f":"B21*12","v":0}]
[]
["TOTAL RETRIB.",{"$f":"SUM(B10+B19+B21)","v":3523.7066666666669},null,null,null,null,null,"TOTAL RETRIB.",{"$f":"SUM(I10+I19+I21)","v":42284.480000000003}]
["Indemnització",{"$f":"(B10+B19+B21)*12/365*B8/12","v":115.8478904109589},null,null,null,null,null,"Indemnització",{"$f":"B24*12","v":1390.1746849315068}]
["Quota patronal",{"$f":"IF(B23>'ValLAB DISTINGIT'!H15,'ValLAB DISTINGIT'!L20*'ValLAB DISTINGIT'!H15,B23*'ValLAB DISTINGIT'!L20)","v":1172.3372080000001},null,null,null,null,null,"Quota patronal",{"$f":"B25*12","v":14068.046496000003}]
["TOTAL COST",{"$f":"SUM(B23,B25)","v":4696.0438746666669},null,null,null,null,null,"TOTAL COST",{"$f":"SUM(B26*12)","v":56352.526496000006}]
[]
[null,null,null,null,null,null,null,"Cost amb marge",{"$f":"SUM(I26*B49)+I26","v":57761.339658400007}]
["COST PERIODE ACTUAL (PRORROGA)"]
[{"$f":"CONCATENATE(B1,\" (\",DAY(B5),\"/\",MONTH(B5),\"/\",YEAR(B5),\"-\",DAY(I5),\"/\",MONTH(I5),\"/\",YEAR(I5),\")\")","v":" (1/10/2024-31/12/2024)"}]
[null,"ACTUAL"]
["Retribucions:",{"$f":"IF(B10=0,0,B10*(D58+(E58/30)))","v":9064.4700000000012}]
[]
["TOTAL EXTRES:",{"$f":"SUM(B35:B36)","v":1506.65}]
["Extra  juny",{"$f":"IF(B19=0,\" \",B19/2*(D58+(E58/30)))","v":753.32500000000005}]
["Extra desembre",{"$f":"IF(B19=0,\" \",(B19/2)*(D58+E58/30))","v":753.32500000000005}]
[]
["Triennis: ",{"$f":"IF(B21=0,0,B21*(D58+E58/30))","v":0}]
[]
["TOTAL RETRIB.",{"$f":"IF(B32=0,0,SUM(B32+B34+B38))","v":10571.12}]
["Indemnització",{"$f":"IF(B24=0,0,B24*(D58+E58/30))","v":347.5436712328767}]
["Quota patronal",{"$f":"IF(B23>'ValLAB DISTINGIT'!H15,B25*(D58+(E58/30)),B40*'ValLAB DISTINGIT'!L20)","v":3517.0116240000002}]
["TOTAL COST",{"$f":"SUM(B40,B42)","v":14088.131624000001}]
[]
["Import L1",{"$f":"B40+B41","v":10918.663671232878}]
["Import L2",{"$f":"SUM(B42)","v":3517.0116240000002}]
[]
["COST PERIODE ACTUAL  AMB MARGE"]
["Marge",2.5000000000000001E-2]
[null,null,null,"Amb arrossegament"]
["Import L1",{"$f":"SUM(B45)+(B45*$B$49)","v":11191.6302630137},"Import L1",{"$f":"SUM(D45)+(D45*$B$49)","v":0}]
["Import L2",{"$f":"SUM(B46+B46*$B$49)","v":3604.9369146000004}]
["                                    TOTAL    ",{"$f":"SUM(B51:B52)","v":14796.567177613701},"Import L2",{"$f":"SUM(D46+D46*$B$49)","v":0}]
[]
["MERITACIÓ ARROSEGAMENT PAGUES"]
[null,"DATA INICI","DATA FI","Nº MESOS","Nº DIES"]
["TOTAL VINCULACIÓ",{"$f":"IF(B4=0,\" \",B4)","v":"2024-10-01"},{"$f":"IF(I5=0,\" \",I5)","v":"2024-12-31"},{"$f":"IF((C57-B57)>0,'calcul dies'!L15,\"ERROR DATES\")","v":3},{"$f":"IF((C57-B57)>0,'calcul dies'!N15,\" \")","v":0}]
["PRORROGA",{"$f":"IF(B5=0,\" \",B5)","v":"2024-10-01"},{"$f":"IF(I5=0,\" \",I5)","v":"2024-12-31"},{"$f":"IF((C58-B58)>0,'calcul dies'!L20,\"ERROR DATES\")","v":3},{"$f":"IF((C58-B58)>0,'calcul dies'!N20,\" \")","v":0}]
["MERITEN",null,"DATA FI","NºMESOS","Nº DIES"]
["de 01/07 a 30/06",null,{"$f":"IF(I5=0,\" \",(I5)-1)","v":"2024-12-30"},{"$f":"IF(B60=0,0,IF((C60-B60)>366,\"ERROR DATA\",IF((C60-B60)>0,'calcul dies'!L15,\"ERR0R DATA \")))","v":0},{"$f":"IF(B60=0,0,IF((C60-B60)>366,\" \",IF((C60-B60)>0,'calcul dies'!N15,\" \")))","v":0}]
["de 01/01 a 31/12",null,{"$f":"IF(I5=0,\" \",(I5)-1)","v":"2024-12-30"},{"$f":"IF(B61=0,0,IF((C61-B61)>366,\"ERROR DATA\",IF((C61-B61)>0,'calcul dies'!L20,\"ERR0R DATA \")))","v":0},{"$f":"IF(B61=0,0,IF((C61-B61)>366,\" \",IF((C61-B61)>0,'calcul dies'!N20,\" \")))","v":0}]
["Indemnització RD",null,{"$f":"IF(I5=0,\" \",(I5)-1)","v":"2024-12-30"},{"$f":"IF(B62=0,0,IF((C62-B62)>366,\"ERROR DATA\",IF((C62-B62)>0,'calcul dies'!#REF!,\"ERR0R DATA \")))","v":0},{"$f":"IF(B62=0,0,IF((C62-B62)>366,\"ERROR DATA\",IF((C62-B62)>0,'calcul dies'!#REF!,\" \")))","v":0}]
["Període treballat al 2014",null,{"$f":"IF(YEAR(I5)>2014,DATE(2014,12,31),IF(I5<>0,I5,\" \"))","v":"2014-12-31"},{"$f":"IF(B63=0,0,IF((C63-B63)>366,\"ERROR DATA\",IF((C63-B63)>0,'calcul dies'!#REF!,\"ERR0R DATA \")))","v":0},{"$f":"IF(B63=0,0,IF((C63-B63)>366,\"ERROR DATA\",IF((C63-B63)>0,'calcul dies'!#REF!,\" \")))","v":0}]

{"sheet":"ValLAB","index":2,"n_rows":59,"n_cols":22,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[]
["Grups","Sou mes","comp.lloc","comp.cat","ACORD MESA",null,"Centre Liquidació","Valor Seg_ Social","Reduccions",null,"Tipus de contractes PR","Centre Liq.","% QP","% RETRIB.","Indemnització",null,null,"Finançament",null,"Conceptes"]
["Postdoctoral",1410.06,188.41,96.63,8.19,null,"005-A",null,1,null,"LABORAL INDEFINIT","006-A",0.32069999999999999,1,"si","Increment retributiu 0,5 març 24 (retroactiu gener23)",null,"Capítol 1",1,"Substitució per alliberament sindical",1,"Persona a substituir categoria, dedicació i periode d'àbsència"]
["Ordinari",1410.06,188.41,944.03,8.19,null,"006-A",null,0.75,null,"TEMPORAL VINCULAT A PROGRAMES FINANÇATS PER FONS EUROPEUS TC (37,5h)","007-A",0.3327,1,"si",null,null,"Fin. Específic",2,"Substitució per IT",2,"Persona substituta, categoria i dedicació"]
["Director",1410.06,188.41,1414.83,8.19,null,"007-A",null,0.6,null,"TEMPORAL VINCULAT A PROGRAMES FINANÇATS PER FONS EUROPEUS TP (<37,5h)",null,0.3327,1,"si",null,null,"Cofinançament",3,"Reforç",3,"Grup i complements"]
[null,null,null,null,null,null,"005-D",null,null,null,null,null,null,null,null,null,null,null,null,"Gratificació",4,"Import /mes"]
[null,null,null,null,null,null,"006-D",null,null,null,null,null,null,null,null,null,null,null,null,"Hores extres / Serveis Extraordinàris",5,"Nombre d'hores"]
["import triennis",54.25,null,null,null,null,"007-D",null,null,null,null,null,null,null,null,null,null,null,null,"Altres (de FDP)",6,"Tipus"]
[null,null,null,null,null,null,"005-80",null,null,null,null,null,null,null,null,null,null,null,"Contractació contra plaça autoritzada",7]
["AMB INCREMENT DEL 2% JULIOL 2024",null,null,null,null,null,"006-80",null,null,null,null,null,null,null,null,null,null,null,"Resolució concurs",8]
[null,null,null,null,null,null,"007-80",null,null,null,null,null,null,null,null,null,null,null,"Altres (d'apunt)",9]
[null,null,null,null,null,null,"001-A",null,null,null,null,null,null,null,null,null,null,null,"Actuació transversal",10,"Acció transversal concreta:"]
[null,null,null,null,null,null,"002-A",null,null,null,null,null,null,null,null,null,null,null,"Actuació general",11,"Tipus + Clau retributiva afectada"]
[null,null,null,null,null,null,null,null,null,"Retribucions"]
["INDEMNITZACIONS",null,null,null,null,"Base max. Cotització 2025",null,4909.5,null,"Grup","Sou","Millora","Hora",null,"per pagues"]
["INDEFINIT",20,null,null,null,null,null,null,null,1,{"$f":"CHOOSE(J16,B3,B4,B5)","v":1410.06},{"$f":"CHOOSE(J16,C3,C4,C5)","v":188.41},{"$f":"CHOOSE(J16,D3,D4,D5)","v":96.63},{"$f":"CHOOSE(J16,E3,E4,E5)","v":8.19},{"$f":"SUM(K16:M16)","v":1695.1}]
["TEMPORAL",12,null,null,null,null,null,null,null,"CLT"]
["FORMATIU",0,null,null,null,null,null,null,null,29,{"$f":"INDEX(F3:F32,J18)","v":7.47}]
[null,null,null,null,null,null,null,null,null,"Centre de Liquidació-Epígraf",null,"% corresponent"]
[null,null,null,null,null,null,null,null,null,1,{"$f":"INDEX(L3:L5,J20)","v":"006-A"},{"$f":"INDEX(M3:M5,J20)","v":0.32069999999999999}]
[]
[]
[]
[]
[]
[]
[]
[2021]
["CATEGORIA","DEDICACIÓ","SOU BASE","COMPL. DE CATEGORIA","COMPL. DE LLOC","ACORD MESA UNIVERSITATS","TRIENNI MENSUAL"]
["Investigador posdoc","TC",1290.49,172.42,88.42,7.47]
["Investigador ordinari/a","TC",1290.49,172.42,863.98,7.47,49.64]
["Director/a de investigació","TC",1290.49,172.42,1294.8499999999999,7.47,49.64]
[]
[2022]
["Investigador posdoc","TC",1316.3,175.87,90.190000000000012,7.62]
["Investigador ordinari/a","TC",1316.3,175.87,881.26,7.62,50.64]
["Director/a de investigació","TC",1316.3,175.87,1320.75,7.62,50.64]
[]
["2022-11-01",1.4999999999999999E-2]
["Investigador posdoc","TC",1335.66,178.46,91.52,7.74,51.39]
["Investigador ordinari/a","TC",1335.66,178.46,894.22,7.74,51.39]
["Director/a de investigació","TC",1335.66,178.46,1340.18,7.74,51.39]
[]
[]
["2023-02-01",2.5000000000000001E-2]
["Investigador posdoc","TC",{"$f":"(C40*$B$45)+C40","v":1369.0515},{"$f":"(D40*$B$45)+D40","v":182.92150000000001},93.807999999999993,7.9335000000000004,52.674750000000003]
["Investigador ordinari/a","TC",{"$f":"(C41*$B$45)+C41","v":1369.0515},182.92150000000001,916.57550000000003,7.9335000000000004,52.674750000000003]
["Director/a de investigació","TC",1369.0515,182.92150000000001,1373.6845000000001,7.9335000000000004,52.674750000000003]
[]
[]
["2023-11-01",5.0000000000000001E-3]
["Investigador posdoc","TC",1375.73,183.82,94.27,7.98,52.94]
["Investigador ordinari/a","TC",1375.73,183.82,921.04,7.98,52.94]
["Director/a de investigació","TC",1375.73,183.82,1380.38,7.98,52.94]
[]
["2024-07-01",0.02]
["Investigador posdoc","TC",1410.06,188.41,96.63000000000001,8.19,54.25]
["Investigador ordinari/a","TC",1410.06,188.41,944.03,8.19,54.25]
["Director/a de investigació","TC",1410.06,188.41,1414.83,8.19,54.25]

{"sheet":"ValLAB_antiga","index":3,"n_rows":54,"n_cols":22,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
[]
["Grups","Sou mes","comp.lloc","comp.cat","ACORD MESA",null,"Centre Liquidació","Valor Seg_ Social","Reduccions",null,"Tipus de contractes PR","Centre Liq.","% QP","% RETRIB.","Indemnització",null,null,"Finançament",null,"Conceptes"]
["Postdoctoral",1375.73,183.82,94.27,7.98,null,"005-A",null,1,null,"LABORAL INDEFINIT","006-A",0.31900000000000001,1,"si",null,null,"Capítol 1",1,"Substitució per alliberament sindical",1,"Persona a substituir categoria, dedicació i periode d'àbsència"]
["Ordinari",1375.73,183.82,921.04,7.98,null,"006-A",null,0.75,null,"TEMPORAL VINCULAT A PROGRAMES FINANÇATS PER FONS EUROPEUS TC (37,5h)","007-A",0.33100000000000002,1,"si",null,null,"Fin. Específic",2,"Substitució per IT",2,"Persona substituta, categoria i dedicació"]
["Director",1375.73,183.82,1380.38,7.98,null,"007-A",null,0.6,null,"TEMPORAL VINCULAT A PROGRAMES FINANÇATS PER FONS EUROPEUS TP (<37,5h)",null,0.33100000000000002,1,"si",null,null,"Cofinançament",3,"Reforç",3,"Grup i complements"]
[null,null,null,null,null,null,"005-D",null,null,null,null,null,null,null,null,null,null,null,null,"Gratificació",4,"Import /mes"]
[null,null,null,null,null,null,"006-D",null,null,null,null,null,null,null,null,null,null,null,null,"Hores extres / Serveis Extraordinàris",5,"Nombre d'hores"]
["import triennis",52.94,null,null,null,null,"007-D",null,null,null,null,null,null,null,null,null,null,null,null,"Altres (de FDP)",6,"Tipus"]
[null,null,null,null,null,null,"005-80",null,null,null,null,null,null,null,null,null,null,null,"Contractació contra plaça autoritzada",7]
[null,null,null,null,null,null,"006-80",null,null,null,null,null,null,null,null,null,null,null,"Resolució concurs",8]
[null,null,null,null,null,null,"007-80",null,null,null,null,null,null,null,null,null,null,null,"Altres (d'apunt)",9]
["retribucions actualitzades amb l'increment 2,5% 2023 ",null,null,null,null,null,"001-A",null,null,null,null,null,null,null,null,null,null,null,"Actuació transversal",10,"Acció transversal concreta:"]
[null,null,null,null,null,null,"002-A",null,null,null,null,null,null,null,null,null,null,null,"Actuació general",11,"Tipus + Clau retributiva afectada"]
[null,null,null,null,null,null,null,null,null,"Retribucions"]
[null,null,null,null,null,"Base max. Cotització 2023",null,4495.5,null,"Grup","Sou","Millora","Hora",null,"per pagues"]
[null,null,null,null,null,null,null,null,null,1,{"$f":"CHOOSE(J16,B3,B4,B5)","v":1375.73},{"$f":"CHOOSE(J16,C3,C4,C5)","v":183.82},{"$f":"CHOOSE(J16,D3,D4,D5)","v":94.27},{"$f":"CHOOSE(J16,E3,E4,E5)","v":7.98},{"$f":"SUM(K16:M16)","v":1653.82}]
[null,null,null,null,null,null,null,null,null,"CLT"]
[null,null,null,null,null,null,null,null,null,29,{"$f":"INDEX(F3:F32,J18)","v":7.47}]
[null,null,null,null,null,null,null,null,null,"Centre de Liquidació-Epígraf",null,"% corresponent"]
[null,null,null,null,null,null,null,null,null,3,{"$f":"INDEX(L3:L5,J20)","v":0},{"$f":"INDEX(M3:M5,J20)","v":0.33100000000000002}]
[]
[]
[]
[]
[]
[]
[]
[2021]
["CATEGORIA","DEDICACIÓ","SOU BASE","COMPL. DE CATEGORIA","COMPL. DE LLOC","ACORD MESA UNIVERSITATS","TRIENNI MENSUAL"]
["Investigador posdoc","TC",1290.49,172.42,88.42,7.47]
["Investigador ordinari/a","TC",1290.49,172.42,863.98,7.47,49.64]
["Director/a de investigació","TC",1290.49,172.42,1294.8499999999999,7.47,49.64]
[]
[2022]
["Investigador posdoc","TC",1316.3,175.87,90.190000000000012,7.62]
["Investigador ordinari/a","TC",1316.3,175.87,881.26,7.62,50.64]
["Director/a de investigació","TC",1316.3,175.87,1320.75,7.62,50.64]
[]
["2022-11-01",1.4999999999999999E-2]
["Investigador posdoc","TC",1335.66,178.46,91.52,7.74,51.39]
["Investigador ordinari/a","TC",1335.66,178.46,894.22,7.74,51.39]
["Director/a de investigació","TC",1335.66,178.46,1340.18,7.74,51.39]
[]
[]
["2023-02-01",2.5000000000000001E-2]
["Investigador posdoc","TC",{"$f":"(C40*$B$45)+C40","v":1369.0515},{"$f":"(D40*$B$45)+D40","v":182.92150000000001},93.807999999999993,7.9335000000000004,52.674750000000003]
["Investigador ordinari/a","TC",{"$f":"(C41*$B$45)+C41","v":1369.0515},182.92150000000001,916.57550000000003,7.9335000000000004,52.674750000000003]
["Director/a de investigació","TC",1369.0515,182.92150000000001,1373.6845000000001,7.9335000000000004,52.674750000000003]
[]
[]
["2023-11-01",5.0000000000000001E-3]
["Investigador posdoc","TC",1375.73,183.82,94.27,7.98,52.94]
["Investigador ordinari/a","TC",1375.73,183.82,921.04,7.98,52.94]
["Director/a de investigació","TC",1375.73,183.82,1380.38,7.98,52.94]

{"sheet":"ValLAB DISTINGIT","index":4,"n_rows":46,"n_cols":22,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
[]
["Grups","Sou mes","comp.lloc","comp.cat","ACORD MESA",null,"Centre Liquidació","Valor Seg_ Social","Reduccions",null,"Tipus de contractes PR DISTINGIT","Centre Liq.","% QP","% RETRIB.","Indemnització",null,null,"Finançament",null,"Conceptes"]
["Postdoctoral",1410.06,188.41,96.63,8.19,null,"005-A",null,1,null,"TEMPORAL TEMPS COMPLET (990-TC)","006-A",0.3327,1,"12 dies","Increment 0,08% MEI Gener2024",null,"Capítol 1",1,"Substitució per alliberament sindical",1,"Persona a substituir categoria, dedicació i periode d'àbsència"]
["Ordinari",1410.06,188.41,944.03,8.19,null,"006-A",null,0.75,null,"TEMPORAL TEMPS PARCIAL  (990-TP)","007-A",0.3327,1,"12 dies",null,null,"Fin. Específic",2,"Substitució per IT",2,"Persona substituta, categoria i dedicació"]
["Director",1410.06,188.41,1414.83,8.19,null,"007-A",null,0.6,null,null,null,null,null,null,null,null,"Cofinançament",3,"Reforç",3,"Grup i complements"]
[null,null,null,null,null,null,"005-D",null,null,null,null,null,null,null,null,null,null,null,null,"Gratificació",4,"Import /mes"]
[null,null,null,null,null,null,"006-D",null,null,null,null,null,null,null,null,null,null,null,null,"Hores extres / Serveis Extraordinàris",5,"Nombre d'hores"]
["import triennis",54.25,null,null,null,null,"007-D",null,null,null,null,null,null,null,null,null,null,null,null,"Altres (de FDP)",6,"Tipus"]
[null,null,null,null,null,null,"005-80",null,null,null,null,null,null,null,null,null,null,null,"Contractació contra plaça autoritzada",7]
["AMB INCREMENT DEL 2% JULIOL 2024",null,null,null,null,null,"006-80",null,null,null,null,null,null,null,null,null,null,null,"Resolució concurs",8]
[null,null,null,null,null,null,"007-80",null,null,null,null,null,null,null,null,null,null,null,"Altres (d'apunt)",9]
[null,null,null,null,null,null,"001-A",null,null,null,null,null,null,null,null,null,null,null,"Actuació transversal",10,"Acció transversal concreta:"]
[null,null,null,null,null,null,"002-A",null,null,null,null,null,null,null,null,null,null,null,"Actuació general",11,"Tipus + Clau retributiva afectada"]
[null,null,null,null,null,null,null,null,null,"Retribucions"]
[null,null,null,null,null,"Base max. Cotització 2025",null,4909.5,null,"Grup","Sou","Millora","Hora",null,"per pagues"]
[null,null,null,null,null,null,null,null,null,2,{"$f":"CHOOSE(J16,B3,B4,B5)","v":1410.06},{"$f":"CHOOSE(J16,C3,C4,C5)","v":188.41},{"$f":"CHOOSE(J16,D3,D4,D5)","v":944.03},{"$f":"CHOOSE(J16,E3,E4,E5)","v":8.19},{"$f":"SUM(K16:M16)","v":2542.5}]
[null,null,null,null,null,null,null,null,null,"CLT"]
[null,null,null,null,null,null,null,null,null,9,{"$f":"INDEX(G3:G13,J18)","v":"007-80"}]
[null,null,null,null,null,null,null,null,null,"Centre de Liquidació-Epígraf",null,"% corresponent"]
[null,null,null,null,null,null,null,null,null,1,{"$f":"INDEX(L3:L4,J20)","v":"006-A"},{"$f":"INDEX(M3:M4,J20)","v":0.3327}]
[]
[]
[]
[]
[]
[]
[]
[2021]
["CATEGORIA","DEDICACIÓ","SOU BASE","COMPL. DE CATEGORIA","COMPL. DE LLOC","ACORD MESA UNIVERSITATS","TRIENNI MENSUAL"]
["Director/a de investigació","TC",1290.49,172.42,1294.8499999999999,7.47,49.64]
[]
[2022]
["Director/a de investigació","TC",1316.3,175.87,1320.75,7.62,50.64]
[]
["2022-11-01"]
["Director/a de investigació","TC",1335.66,178.46,1340.18,7.74,51.39]
[]
["2023-02-01",2.5000000000000001E-2]
["Director/a de investigació","TC",{"$f":"(C36*$B$38)+C36","v":1369.0515},{"$f":"(D36*$B$38)+D36","v":182.92150000000001},{"$f":"(E36*$B$38)+E36","v":1373.6845000000001},{"$f":"(F36*$B$38)+F36","v":7.9335000000000004},{"$f":"(G36*$B$38)+G36","v":52.674750000000003}]
[]
[]
["2023-11-01",5.0000000000000001E-3]
["Director/a de investigació","TC",1375.73,183.82,1380.38,7.98,52.94]
[]
["2024-07-01",0.02]
["Director/a de investigació","TC",1410.06,188.41,1414.83,8.19,54.25]

{"sheet":"ValLAB DISTINGIT_antiga","index":5,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[]
["Grups","Sou mes","comp.lloc","comp.cat","ACORD MESA",null,"Centre Liquidació","Valor Seg_ Social","Reduccions",null,"Tipus de contractes PR DISTINGIT","Centre Liq.","% QP","% RETRIB.","Indemnització",null,null,"Finançament",null,"Conceptes"]
["Postdoctoral",1375.73,183.82,94.27,7.98,null,"005-A",null,1,null,"TEMPORAL TEMPS COMPLET (990-TC)","006-A",0.33100000000000002,1,"12 dies",null,null,"Capítol 1",1,"Substitució per alliberament sindical",1,"Persona a substituir categoria, dedicació i periode d'àbsència"]
["Ordinari",1375.73,183.82,921.04,7.98,null,"006-A",null,0.75,null,"TEMPORAL TEMPS PARCIAL  (990-TP)","007-A",0.33100000000000002,1,"12 dies",null,null,"Fin. Específic",2,"Substitució per IT",2,"Persona substituta, categoria i dedicació"]
["Director",1375.73,183.82,1380.38,7.98,null,"007-A",null,0.6,null,null,null,null,null,null,null,null,"Cofinançament",3,"Reforç",3,"Grup i complements"]
[null,null,null,null,null,null,"005-D",null,null,null,null,null,null,null,null,null,null,null,null,"Gratificació",4,"Import /mes"]
[null,null,null,null,null,null,"006-D",null,null,null,null,null,null,null,null,null,null,null,null,"Hores extres / Serveis Extraordinàris",5,"Nombre d'hores"]
["import triennis",52.94,null,null,null,null,"007-D",null,null,null,null,null,null,null,null,null,null,null,null,"Altres (de FDP)",6,"Tipus"]
[null,null,null,null,null,null,"005-80",null,null,null,null,null,null,null,null,null,null,null,"Contractació contra plaça autoritzada",7]
[null,null,null,null,null,null,"006-80",null,null,null,null,null,null,null,null,null,null,null,"Resolució concurs",8]
["retribucions actualitzades amb l'increment previst 2023",null,null,null,null,null,"007-80",null,null,null,null,null,null,null,null,null,null,null,"Altres (d'apunt)",9]
[null,null,null,null,null,null,"001-A",null,null,null,null,null,null,null,null,null,null,null,"Actuació transversal",10,"Acció transversal concreta:"]
[null,null,null,null,null,null,"002-A",null,null,null,null,null,null,null,null,null,null,null,"Actuació general",11,"Tipus + Clau retributiva afectada"]
[null,null,null,null,null,null,null,null,null,"Retribucions"]
[null,null,null,null,null,"Base max. Cotització 2023",null,4495.5,null,"Grup","Sou","Millora","Hora",null,"per pagues"]
[null,null,null,null,null,null,null,null,null,2,{"$f":"CHOOSE(J16,B3,B4,B5)","v":1375.73},{"$f":"CHOOSE(J16,C3,C4,C5)","v":183.82},{"$f":"CHOOSE(J16,D3,D4,D5)","v":921.04},{"$f":"CHOOSE(J16,E3,E4,E5)","v":7.98},{"$f":"SUM(K16:M16)","v":2480.59}]
[null,null,null,null,null,null,null,null,null,"CLT"]
[null,null,null,null,null,null,null,null,null,9,{"$f":"INDEX(G3:G13,J18)","v":"007-80"}]
[null,null,null,null,null,null,null,null,null,"Centre de Liquidació-Epígraf",null,"% corresponent"]
[null,null,null,null,null,null,null,null,null,2,{"$f":"INDEX(L3:L4,J20)","v":"007-A"},{"$f":"INDEX(M3:M4,J20)","v":0.33100000000000002}]
[]
[]
[]
[]
[]
[]
[]
[2021]
["CATEGORIA","DEDICACIÓ","SOU BASE","COMPL. DE CATEGORIA","COMPL. DE LLOC","ACORD MESA UNIVERSITATS","TRIENNI MENSUAL"]
["Director/a de investigació","TC",1290.49,172.42,1294.8499999999999,7.47,49.64]
[]
[2022]
["Director/a de investigació","TC",1316.3,175.87,1320.75,7.62,50.64]
[]
["2022-11-01"]
["Director/a de investigació","TC",1335.66,178.46,1340.18,7.74,51.39]
[]
["2023-02-01",2.5000000000000001E-2]
["Director/a de investigació","TC",{"$f":"(C36*$B$38)+C36","v":1369.0515},{"$f":"(D36*$B$38)+D36","v":182.92150000000001},{"$f":"(E36*$B$38)+E36","v":1373.6845000000001},{"$f":"(F36*$B$38)+F36","v":7.9335000000000004},{"$f":"(G36*$B$38)+G36","v":52.674750000000003}]
[]
[]
["2023-11-01",5.0000000000000001E-3]
["Director/a de investigació","TC",1375.73,183.82,1380.38,7.98,52.94]

{"sheet":"calcul dies","index":6,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,13],[2,4,2,13],[7,4,7,13],[12,4,12,13],[17,4,17,13]]}
["CALCULS DIES LABORALS NO TOPATS"]
[]
["dies pr",null,null,null,"CÀLCUL DIES pr"]
[null,"DATA INICI","DATA FI",null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
["TOTAL VINCULACIÓ",{"$f":"PR!B64","v":"2025-01-01"},{"$f":"PR!H5","v":"2025-12-31"},null,"INICI VINCULACIÓ",{"$f":"DAY(B5)","v":1},{"$f":"MONTH(B5)","v":1},{"$f":"YEAR(B5)","v":2025},null,{"$f":"IF(F5>1,-1,0)","v":0},{"$f":"IF(F5=1,-M5,0)","v":-31},{"$f":"IF(H5=H6,G6-G5+1,13-G5+G6+(H6-H5-1)*12)+J5+J6","v":12},{"$f":"IF(G5=1,31-F5,IF(G5=2,28-F5,IF(G5=3,31-F5,IF(G5=4,30-F5,IF(G5=5,31-F5,IF(G5=6,30-F5,IF(G5=7,31-F5,IF(G5=8,31-F5,IF(G5=9,30-F5,IF(G5=10,31-F5,IF(G5=11,30-F5,IF(G5=12,31-F5))))))))))))+1","v":31},{"$f":"SUM(K5+M5+M6)","v":0}]
["PRORROGA",{"$f":"PR!B65","v":"2025-01-01"},{"$f":"PR!H5","v":"2025-12-31"},null,"FI VINCULACIÓ",{"$f":"DAY(C5)","v":31},{"$f":"MONTH(C5)","v":12},{"$f":"YEAR(C5)","v":2025},null,{"$f":"IF(AND(G6=1,F6=31),0,IF(AND(G6=2,28=F6),0,IF(AND(G6=3,31=F6),0,IF(AND(G6=4,30=F6),0,IF(AND(G6=5,31=F6),0,IF(AND(G6=6,30=F6),0,IF(AND(G6=7,31=F6),0,IF(AND(G6=8,31=F6),0,IF(AND(G6=9,30=F6),0,IF(AND(G6=10,31=F6),0,IF(AND(G6=11,30=F6),0,IF(AND(G6=12,31=F6),0,-1))))))))))))","v":0},null,null,{"$f":"IF(AND(G6=1,F6<>31),F6,IF(AND(G6=2,28<>F6),F6,IF(AND(G6=3,31<>F6),F6,IF(AND(G6=4,30<>F6),F6,IF(AND(G6=5,31<>F6),F6,IF(AND(G6=6,30<>F6),F6,IF(AND(G6=7,31<>F6),F6,IF(AND(G6=8,31<>F6),F6,IF(AND(G6=9,30<>F6),F6,IF(AND(G6=10,31<>F6),F6,IF(AND(G6=11,30<>F6),F6,IF(AND(G6=12,31<>F6),F6,0))))))))))))","v":0}]
["dies pr distingit"]
["TOTAL VINCULACIÓ",{"$f":"'PR DISTINGIT '!B57","v":"2024-10-01"},{"$f":"'PR DISTINGIT '!C57","v":"2024-12-31"},null,"CÀLCUL DIES PRÒRROGA pr"]
["PRORROGA",{"$f":"'PR DISTINGIT '!B58","v":"2024-10-01"},{"$f":"'PR DISTINGIT '!C58","v":"2024-12-31"},null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
[null,null,null,null,"INICI PRORROGA",{"$f":"DAY(B6)","v":1},{"$f":"MONTH(B6)","v":1},{"$f":"YEAR(B6)","v":2025},null,{"$f":"IF(F10>1,-1,0)","v":0},{"$f":"IF(F10=1,-M10,0)","v":-31},{"$f":"IF(H10=H11,G11-G10+1,13-G10+G11+(H11-H10-1)*12)+J10+J11","v":12},{"$f":"IF(G10=1,31-F10,IF(G10=2,28-F10,IF(G10=3,31-F10,IF(G10=4,30-F10,IF(G10=5,31-F10,IF(G10=6,30-F10,IF(G10=7,31-F10,IF(G10=8,31-F10,IF(G10=9,30-F10,IF(G10=10,31-F10,IF(G10=11,30-F10,IF(G10=12,31-F10))))))))))))+1","v":31},{"$f":"SUM(K10+M10+M11)","v":0}]
[null,null,null,null,"FI VINCULACIÓ",{"$f":"DAY(C5)","v":31},{"$f":"MONTH(C5)","v":12},{"$f":"YEAR(C5)","v":2025},null,{"$f":"IF(AND(G11=1,F11=31),0,IF(AND(G11=2,28=F11),0,IF(AND(G11=3,31=F11),0,IF(AND(G11=4,30=F11),0,IF(AND(G11=5,31=F11),0,IF(AND(G11=6,30=F11),0,IF(AND(G11=7,31=F11),0,IF(AND(G11=8,31=F11),0,IF(AND(G11=9,30=F11),0,IF(AND(G11=10,31=F11),0,IF(AND(G11=11,30=F11),0,IF(AND(G11=12,31=F11),0,-1))))))))))))","v":0},null,null,{"$f":"IF(AND(G11=1,F11<>31),F11,IF(AND(G11=2,28<>F11),F11,IF(AND(G11=3,31<>F11),F11,IF(AND(G11=4,30<>F11),F11,IF(AND(G11=5,31<>F11),F11,IF(AND(G11=6,30<>F11),F11,IF(AND(G11=7,31<>F11),F11,IF(AND(G11=8,31<>F11),F11,IF(AND(G11=9,30<>F11),F11,IF(AND(G11=10,31<>F11),F11,IF(AND(G11=11,30<>F11),F11,IF(AND(G11=12,31<>F11),F11,0))))))))))))","v":0}]
[]
[null,null,null,null,"CÀLCUL DIES pr DISTINGIT"]
[null,null,null,null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
[null,null,null,null,"INICI",{"$f":"DAY(B8)","v":1},{"$f":"MONTH(B8)","v":10},{"$f":"YEAR(B8)","v":2024},null,{"$f":"IF(F15>1,-1,0)","v":0},{"$f":"IF(F15=1,-M15,0)","v":-31},{"$f":"IF(H15=H16,G16-G15+1,13-G15+G16+(H16-H15-1)*12)+J15+J16","v":3},{"$f":"IF(G15=1,31-F15,IF(G15=2,28-F15,IF(G15=3,31-F15,IF(G15=4,30-F15,IF(G15=5,31-F15,IF(G15=6,30-F15,IF(G15=7,31-F15,IF(G15=8,31-F15,IF(G15=9,30-F15,IF(G15=10,31-F15,IF(G15=11,30-F15,IF(G15=12,31-F15))))))))))))+1","v":31},{"$f":"SUM(K15+M15+M16)","v":0}]
[null,null,null,null,"FI",{"$f":"DAY(C8)","v":31},{"$f":"MONTH(C8)","v":12},{"$f":"YEAR(C8)","v":2024},null,{"$f":"IF(AND(G16=1,F16=31),0,IF(AND(G16=2,28=F16),0,IF(AND(G16=3,31=F16),0,IF(AND(G16=4,30=F16),0,IF(AND(G16=5,31=F16),0,IF(AND(G16=6,30=F16),0,IF(AND(G16=7,31=F16),0,IF(AND(G16=8,31=F16),0,IF(AND(G16=9,30=F16),0,IF(AND(G16=10,31=F16),0,IF(AND(G16=11,30=F16),0,IF(AND(G16=12,31=F16),0,-1))))))))))))","v":0},null,null,{"$f":"IF(AND(G16=1,F16<>31),F16,IF(AND(G16=2,28<>F16),F16,IF(AND(G16=3,31<>F16),F16,IF(AND(G16=4,30<>F16),F16,IF(AND(G16=5,31<>F16),F16,IF(AND(G16=6,30<>F16),F16,IF(AND(G16=7,31<>F16),F16,IF(AND(G16=8,31<>F16),F16,IF(AND(G16=9,30<>F16),F16,IF(AND(G16=10,31<>F16),F16,IF(AND(G16=11,30<>F16),F16,IF(AND(G16=12,31<>F16),F16,0))))))))))))","v":0}]
[]
[null,null,null,null,"CÀLCUL DIES PRÒRROGA pr DISTINGIT"]
[null,null,null,null,null,"DIA","MES ","ANY",null,"dif mesos","dif dies","total mesos","dies","total dies"]
[null,null,null,null,"INICI",{"$f":"DAY(B9)","v":1},{"$f":"MONTH(B9)","v":10},{"$f":"YEAR(B9)","v":2024},null,{"$f":"IF(F20>1,-1,0)","v":0},{"$f":"IF(F20=1,-M20,0)","v":-31},{"$f":"IF(H20=H21,G21-G20+1,13-G20+G21+(H21-H20-1)*12)+J20+J21","v":3},{"$f":"IF(G20=1,31-F20,IF(G20=2,28-F20,IF(G20=3,31-F20,IF(G20=4,30-F20,IF(G20=5,31-F20,IF(G20=6,30-F20,IF(G20=7,31-F20,IF(G20=8,31-F20,IF(G20=9,30-F20,IF(G20=10,31-F20,IF(G20=11,30-F20,IF(G20=12,31-F20))))))))))))+1","v":31},{"$f":"SUM(K20+M20+M21)","v":0}]
[null,null,null,null,"FI",{"$f":"DAY(C9)","v":31},{"$f":"MONTH(C9)","v":12},{"$f":"YEAR(C9)","v":2024},null,{"$f":"IF(AND(G21=1,F21=31),0,IF(AND(G21=2,28=F21),0,IF(AND(G21=3,31=F21),0,IF(AND(G21=4,30=F21),0,IF(AND(G21=5,31=F21),0,IF(AND(G21=6,30=F21),0,IF(AND(G21=7,31=F21),0,IF(AND(G21=8,31=F21),0,IF(AND(G21=9,30=F21),0,IF(AND(G21=10,31=F21),0,IF(AND(G21=11,30=F21),0,IF(AND(G21=12,31=F21),0,-1))))))))))))","v":0},null,null,{"$f":"IF(AND(G21=1,F21<>31),F21,IF(AND(G21=2,28<>F21),F21,IF(AND(G21=3,31<>F21),F21,IF(AND(G21=4,30<>F21),F21,IF(AND(G21=5,31<>F21),F21,IF(AND(G21=6,30<>F21),F21,IF(AND(G21=7,31<>F21),F21,IF(AND(G21=8,31<>F21),F21,IF(AND(G21=9,30<>F21),F21,IF(AND(G21=10,31<>F21),F21,IF(AND(G21=11,30<>F21),F21,IF(AND(G21=12,31<>F21),F21,0))))))))))))","v":0}]